SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483990 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483990 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142079,847416,1026188,1040902,195162,714413,153782,797957,771295,24358,994061,89632,234713,91822,104106,35905,1043610,919726,369916,34644,709364,64370,426456,774626,703917,43803,619664,330691,12988,178275,34157,251658,569465,476369,970907,144580,812565,1002073,562906,895710,914653,133944,977485,677446,204527,601297,956996,805839,223160,509040,853149,593929,400001,257987,478697,781953,969331,859699,714122,787224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]