SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344051 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344051 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114805,841982,5761,834714,927541,1006390,579376,766417,6086,296890,940256,748547,956257,21658,60744,329714,563773,421279,477386,461870,641183,313886,866751,594290,52419,750030,613036,766101,14641,274986,499201,432438,597544,534402,750257,20683,305526,985116,420616,864614,842987,563790,123103,913864,601756,452912,665917,1022109,458260,311122,236509,550927,929853,758202,877869,153507,324782,262814,675869,788637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]