SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984396 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984396 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458455,943405,739345,313722,582076,523109,350353,843658,872812,774734,850068,464191,178859,277,409601,340349,441738,918147,750552,960438,567580,636700,522203,35277,911456,12862,196530,147523,691913,644733,380250,288441,956044,372726,1022718,657964,857252,392183,131192,264535,555266,647360,295846,745116,460931,1024900,956068,837564,956374,815666,154229,730694,682953,718429,25627,143452,333193,243410,183805,79011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]