SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420891 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420891 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209077,934805,107919,226789,246189,962204,809998,158477,129945,152449,820273,785394,102621,184743,712445,561638,67201,526943,384226,20799,960931,751180,67975,681408,887579,374521,127654,212573,299032,600465,248976,285687,518597,370016,49906,132389,596929,680901,1032880,62554,822141,233114,973059,33579,750435,805313,557989,985434,607035,671035,333800,799210,888707,148520,926410,340301,579332,822888,1025620,1033991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002908s ]