SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537964 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537964 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721269,917222,799535,248467,1031433,572020,592852,546121,144150,377709,66951,742114,770159,591220,292089,897589,851121,893779,123195,834873,897857,522483,49909,398448,648911,973274,406842,950118,837417,708412,579281,990946,571971,713400,851824,453955,149628,110231,12647,143706,68901,826633,655122,957431,701125,411162,774763,347677,466937,293663,555382,502218,359781,672695,866522,733953,155645,1044064,7429,1027993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]