SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291318 LIMIT 1 [ RunTime:0.001887s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291318 [ RunTime:0.006279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044485,766572,500779,719613,581932,41553,231812,529602,112792,953883,788263,1038382,762136,823133,363761,366701,929597,664249,285415,740462,314257,312783,158386,97490,329032,250378,412552,976710,208338,795599,360464,792811,362692,862072,73235,941989,994373,447693,298936,411803,907073,901304,567812,1010633,562184,793427,317285,902159,901469,517307,301157,346588,933493,867603,119078,661427,353058,505856,878825,1029164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]