SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150523 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150523 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020411,675284,481118,359518,587051,220281,557238,350215,77977,964588,1254,271687,830740,346212,853987,903305,490316,265012,1029604,106731,593499,807277,679687,609539,830521,668516,784930,879863,334590,227919,984007,269832,751483,288111,973926,424336,184510,224759,935957,742336,552334,214753,661715,726979,565830,18331,86035,149480,732053,867549,763835,812998,473381,806695,368816,798321,961457,1001745,638340,598035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]