SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438685 LIMIT 1 [ RunTime:0.000274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438685 [ RunTime:0.001398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276654,661489,637427,175718,21809,778897,461682,490032,843061,327489,387071,387020,87810,141598,767803,694886,104847,367040,112694,1031071,82128,72751,715288,918255,470541,346100,1026153,640512,388105,833545,695178,642673,842867,856323,900432,788753,879165,908624,437843,961272,488708,877866,279816,199191,164997,566440,804329,627881,611948,858060,533447,788312,510130,3702,562684,696019,217550,37323,491336,739308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]