SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001798s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414047 LIMIT 1 [ RunTime:0.001670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414047 [ RunTime:0.003361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136014,242025,494845,918194,336496,384988,695801,773404,722498,1042164,1046909,555723,598985,20337,761181,305637,672987,1005872,192355,793617,15984,46862,59219,495709,687660,1040707,645018,592772,687769,338085,743368,71465,644285,803700,940761,919841,611791,769140,1025379,485480,1002944,249602,1033149,141568,879642,710206,825840,872637,434769,632118,762080,215484,383595,689484,840027,746258,684766,770757,373060,911522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]