SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432016 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432016 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821540,114843,645939,791378,159737,249817,1010794,649490,452365,1036391,45131,854995,684480,363535,509543,128441,825470,799063,28897,235214,788131,215446,985433,312245,507840,540566,30176,374736,126613,120110,382279,537967,267093,698374,974927,700915,579487,658154,731265,101924,978359,651895,569200,14751,911704,680628,551586,392245,705511,843012,368891,767002,407659,448200,215777,1025901,94976,69290,635375,101168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]