SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496611 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496611 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240048,910458,13681,716492,850525,15571,802462,869873,564235,917768,262367,694263,214953,22883,21351,102009,932138,347955,340419,232368,642936,1003788,769675,866745,1002479,745377,1011905,388792,588838,883149,386864,681771,712402,165273,157875,512251,418436,997181,245489,1028756,165519,731874,620830,827876,728540,240113,395695,741187,810984,518219,10885,796482,641878,691941,73289,933758,1041829,704658,649954,17708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]