SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550100 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550100 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555810,168466,577413,380721,299561,943285,598921,600802,904049,634014,157141,123969,927891,266217,251488,959117,826093,607010,746693,518501,592471,809300,465318,747046,539252,1005384,202918,759955,557994,535919,259015,293291,866646,693959,279267,344345,788444,515804,655026,516863,405605,46859,599781,503966,689476,366546,135796,234124,56895,273780,1047277,133694,108333,403666,778077,532257,815107,292666,808358,808459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]