SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445059 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445059 [ RunTime:0.002508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025638,136701,417203,569187,262411,524218,395237,907399,530010,839033,812008,56583,824022,804750,343746,1036405,299598,278589,607464,794402,122322,293457,628502,773404,568137,931556,109775,369555,910088,359480,697700,49849,777121,1017216,984702,1025950,572224,595537,522116,14893,325244,10434,983981,495354,440349,386838,437589,520810,138402,69619,967957,668304,289472,566112,502500,287202,211506,830578,372201,232954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]