SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419049 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419049 [ RunTime:0.003705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906686,404362,995264,816098,875206,641463,328437,700932,299923,104108,875184,292936,940135,335599,927864,212561,524720,189768,669155,374356,144367,199773,760319,422912,350484,651732,90703,902873,410321,712301,95089,640313,376073,685256,281959,748347,230455,868704,978850,751292,101457,999725,156927,279569,392485,444843,134197,389002,1031954,620414,1011747,686929,236350,480943,584097,895875,333729,639386,890225,826921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]