SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 622005 LIMIT 1 [ RunTime:0.001910s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 622005 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19116,610036,1002876,624719,120010,1004061,56962,947672,947763,174929,115903,405976,876397,523334,962021,1003836,921722,503991,46918,998372,565627,565821,854069,263203,75276,864963,606455,323872,931341,1037014,367228,827853,344869,987186,43839,701546,1021145,1012449,156731,298015,244673,1021463,741854,584140,30586,474929,944745,475518,743773,534794,862861,951402,518419,211718,443266,1012652,690557,204839,306237,278024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 622005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 622005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]