SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001854s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537611 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537611 [ RunTime:0.009459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24739,496880,904335,536379,639132,935637,205351,200243,459744,840584,376927,494893,717568,509380,494798,805662,700794,977992,763674,724126,853751,745658,911633,220503,277360,620642,756500,471716,252320,555098,195776,692310,492194,1036249,526497,1029501,840554,603593,588857,345578,28845,1045099,866535,233317,164591,1029899,892706,425056,793609,117978,74606,31502,672586,754735,700348,599610,817653,951392,436189,731765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]