SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415560 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415560 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765215,778220,168122,763339,263159,386782,132155,350159,207078,250638,448607,4017,284987,411423,658990,729635,128172,413608,1043613,502177,523520,780840,728833,375831,52159,969661,489232,158940,953033,296447,481535,921374,1044752,229528,515212,729065,24984,423292,959521,860737,895818,999104,1002348,898152,479324,847849,463093,300811,800825,644334,942526,789296,969064,59950,523675,228938,125826,123602,737726,104413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]