SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410003 LIMIT 1 [ RunTime:0.002760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410003 [ RunTime:0.003696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333806,789109,217137,258648,482706,269886,248566,321992,1023446,993841,239356,273403,685048,678740,596985,338566,846864,240391,403215,979918,673784,760404,30137,711145,400522,904765,132404,155312,1028989,934837,599163,216744,22817,1027716,40242,590014,743354,913317,990054,533671,671723,740618,393369,198530,567976,81913,282448,94900,381266,212800,630083,454419,522129,272048,355627,545938,548147,696953,836451,998758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001176s ]