SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504524 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504524 [ RunTime:0.002241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854803,499891,308781,382204,51038,984686,776008,383229,377206,452774,646857,437174,830844,44413,814512,985666,308094,122900,548056,808246,198943,68753,176257,89015,727277,696001,591968,963899,477106,97984,17559,789797,88322,726211,454903,69880,147886,88158,878032,427592,804466,169011,889237,839161,672821,277582,419767,476600,944425,387648,896899,501570,330580,647949,910852,736113,649439,682115,1013444,780543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]