SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267520 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267520 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784054,968532,914925,176747,258634,662488,364388,576764,164964,242585,487436,226244,234849,1036937,764141,433656,41863,473764,690453,917925,87991,979108,138688,482391,722608,900966,180607,131269,29130,903283,11088,173996,409076,170578,427010,901926,132114,939450,948889,755963,846563,236613,163987,136392,85325,662776,167560,158117,641303,249811,791227,167824,937066,156030,215563,1047471,363337,544990,712273,710181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]