SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297528 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297528 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170291,1031744,620738,380280,436140,891624,898073,42287,553057,141072,314015,175754,299958,68182,932053,82139,263896,466723,260509,470034,298581,451003,15890,399335,2040,650672,723450,732617,70049,901914,362865,601058,665000,79545,579208,559985,570790,749641,833913,320832,621982,408746,1005748,793577,251766,439817,659390,624292,133082,964374,853770,681711,951632,853190,613083,830813,926024,595301,119086,84570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]