SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408652 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408652 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144844,721628,1048365,271774,164821,1007936,443169,136875,468511,364794,352687,1029629,592903,560431,383261,350014,27798,1014739,468892,639012,439591,391125,130463,1037855,244664,906192,636185,1047605,334721,961925,483464,678033,470475,487635,70522,966192,779925,662815,282264,422192,926485,931276,219187,239568,144452,1008972,308555,1042843,753115,980718,1041214,606620,344360,383405,855610,415350,1045386,334806,148740,731974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]