SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514506 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514506 [ RunTime:0.002552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192418,410987,697740,593534,403374,433876,809220,413771,284555,815140,1022855,1865,736516,896735,932126,916331,81595,284972,2812,305754,772817,573311,325381,1024447,786464,779052,29816,479679,754117,393398,315726,967822,594348,757799,831944,1007333,369512,416577,784360,489697,470548,707111,75437,25588,831,812281,328285,10352,990233,243908,920225,1004692,142362,969537,658055,912837,763383,899857,940122,511339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]