SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411642 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411642 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327965,569418,15109,298311,21669,224730,723959,985096,329452,927039,897470,1005089,158862,774741,231395,948766,833308,316206,621964,897029,363850,695245,466955,205235,764204,203833,716151,741152,1031518,423166,794881,954872,829687,185552,485812,42145,521033,769605,855235,1010620,165679,305233,870345,539736,172156,343830,252540,281579,952500,743499,1021775,695588,519373,784979,152474,930835,513543,232549,420027,558204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]