SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631580 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631580 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549011,551864,1044987,755928,53054,542872,1025696,898198,986320,474463,770725,147136,1031908,112079,120536,40468,326469,647403,919668,944747,200583,214026,296651,849267,211322,541456,79946,989723,214627,887054,361013,455394,123811,82475,824810,439071,969874,1043619,127573,138388,891694,787554,372455,381879,173164,1031533,552178,704971,908704,165007,156655,182079,276540,946739,590482,835194,176359,221439,442331,120162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]