SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508578 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508578 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595057,108484,867035,449079,775806,949769,29226,821216,553584,383077,390120,20980,174312,308529,304383,481892,808866,905254,264825,646946,91601,882535,871562,169897,980843,302230,1034365,460343,826409,866407,853750,55970,486503,501505,522664,233682,21103,311376,464304,184574,919819,182874,438915,953027,218969,916572,587362,504475,863878,246841,402858,1013476,508088,66496,952821,257619,71198,449038,116651,616199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]