SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 18191 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 18191 [ RunTime:0.003903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129081,191653,775159,174561,1037526,73307,998799,132233,268591,329083,372067,431244,647754,873333,930758,801963,182995,830763,1029062,717590,518387,852965,1003133,795029,184490,698687,32824,490702,570304,967031,767561,203494,146678,1031618,314909,662585,951731,92232,686442,198153,710784,554005,113889,850303,907688,437183,199633,489594,361983,788796,575444,727896,971318,379528,167810,541370,403374,828926,61156,878752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 18191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 18191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]