SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409599 LIMIT 1 [ RunTime:0.000576s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409599 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581809,372697,61479,462678,371246,292205,196557,34674,188951,511416,165591,472565,414643,378802,959800,719456,975483,673555,547359,220422,811378,29279,9641,597693,479789,809081,618031,506697,175977,686225,315731,580361,182282,205127,909211,5773,785624,185640,654144,347897,35409,894114,265700,235403,232881,911620,823093,709220,38801,594965,923281,705645,542812,30499,315487,309390,691459,905305,500557,211669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]