SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398358 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398358 [ RunTime:0.002977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84282,378268,1006413,21650,842383,168077,49887,167754,215203,896396,738495,945894,1036385,239611,410078,20999,189436,234154,887147,51357,332272,936498,240488,184916,579958,555575,314564,11487,943098,759420,80818,888386,790446,391329,552887,741517,842876,739942,847936,657683,686546,558381,4584,102029,525551,382933,834200,82396,205756,450205,37607,911660,910096,914356,753650,178990,836820,38221,584630,600948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]