SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50392 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50392 [ RunTime:0.002426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903115,677614,722834,828363,718181,441270,167750,1044330,116435,360766,518047,643952,211881,633698,454611,804486,340095,879264,429802,304906,343245,919736,616923,876147,331811,828417,198847,621205,773803,1017260,955548,833902,127169,119326,1021479,644724,727277,923798,144965,141277,486790,778461,250354,845234,148534,153567,658252,577799,169117,935704,287408,494522,434091,645318,327305,773319,243780,253528,985096,144627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]