SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402730 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402730 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896804,579025,946636,582849,665679,741499,589241,1011270,447791,971993,506434,476165,537898,596221,850376,150613,502516,49547,294305,149542,416885,804677,424898,759289,792210,1030952,422127,141464,120517,472716,936832,861804,520788,631208,810066,164542,217253,653297,301140,151093,271586,750971,832291,545812,558500,907571,613890,723003,8657,759922,322874,503416,291985,1016896,1034562,715547,861960,401746,169998,196151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]