SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403276 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403276 [ RunTime:0.003032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509310,228740,283012,21323,508788,519110,964455,958153,293668,84,69966,1021269,760678,426060,511297,1026844,599952,728431,567680,446107,279915,612196,684571,785838,317964,670369,126091,56524,315381,417669,115458,828440,84829,1037818,576065,141600,675695,232282,158547,522435,383432,285895,982425,176181,887398,455623,59483,1007576,794297,839806,370422,493435,649886,14977,768497,858204,146292,662965,100976,229121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]