SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528400 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528400 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55599,199109,1042174,514198,350073,1008917,565951,584530,87888,593750,505873,228979,903726,93238,95364,403800,174775,395000,571734,654853,524113,1012149,53176,765793,221309,333519,399107,529573,944815,789432,966010,655006,448482,847691,1015935,1009081,875911,202853,60089,308867,370263,860063,766845,952291,826097,811730,802361,664087,258435,680009,840142,55233,930483,140272,221175,578566,839570,5853,768871,173866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]