SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451500 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451500 [ RunTime:0.004193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802105,935478,662179,310223,521774,558177,685061,268426,924405,556107,263859,493429,16039,1024422,653440,753874,66283,323157,581809,430548,754122,823820,332009,227337,563443,969305,724852,970223,977622,865071,386737,60638,140722,592024,686533,234386,57184,970193,585261,559544,852550,861098,192721,561150,1013497,1011989,437189,472340,35968,786049,812070,427018,1047661,19694,802922,394868,313478,295396,439297,958017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]