SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549445 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549445 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915684,646435,924230,70994,77610,418951,903929,974548,401644,731599,20502,72015,667224,889841,156991,488680,676144,926566,833706,715518,902260,923658,104130,11046,400337,736739,881966,938578,225680,405357,658056,885663,428380,385706,814888,961483,617858,350204,459005,401048,387241,262618,618041,149810,424899,543386,156155,533926,558221,751822,989460,288281,698944,94422,764459,608042,543394,205151,687659,389759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]