SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509260 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509260 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627599,396042,619112,217668,124646,426776,1016821,112576,824716,534725,500858,92800,130677,731199,938959,551687,348893,644297,373521,757489,712167,545798,853120,590464,814291,667044,712773,911369,72225,271805,719674,457921,398960,364325,16855,430417,432205,780547,86800,872778,467839,840997,190379,879592,498784,614993,192098,967272,943787,885646,672268,189146,382178,104217,428122,398935,351550,79485,716231,21612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002652s ]