SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025391 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025391 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94653,109233,76113,198498,214932,355030,71857,655346,151879,618087,843488,232342,88898,752744,324543,29572,268246,414201,687272,1037608,196588,724730,82965,896997,100561,880077,289124,1030796,335494,756531,265229,113707,628960,416005,154410,487114,543469,617994,589219,660211,313216,51745,88692,838362,663024,121179,1040652,131574,366320,87233,454468,713769,458074,849077,140660,944899,77590,966756,928936,733178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]