SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516668 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516668 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551380,94731,453475,854077,268614,827762,2675,564440,943790,961675,683920,962299,608672,145481,487153,110176,223634,200037,280704,741213,518264,40557,1023045,67047,769009,449132,132263,7059,112129,399704,899887,571535,595689,848454,657885,148906,449883,180484,177997,265159,925619,297336,966650,280962,234676,47074,1288,911622,607354,324499,307493,520919,151599,781903,521795,864766,41036,1017199,813755,399154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]