SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001904s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440678 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440678 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648309,912290,535077,1032147,36780,941071,224021,454734,1043572,232519,800167,569100,708805,751523,968878,731813,988855,925556,13930,170662,754142,996146,561890,533994,843038,519572,617346,2736,1009793,495942,600394,722850,486386,6361,114358,493803,627483,283417,219380,332811,683928,26380,782591,352527,703404,15960,116725,92391,87015,312802,768815,938069,628677,441955,930774,108990,213850,345749,423675,710341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]