SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542376 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542376 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78548,976670,858498,817728,1040779,850854,955090,450318,636817,65614,248859,852393,623567,1047404,994396,688202,966507,987071,272856,312777,301683,4783,754113,1003206,862129,225827,151978,425818,306759,925446,213034,39047,253130,94906,252910,291824,582657,530643,646905,675988,604084,867494,486766,688144,280125,217431,67268,496320,702628,637926,465386,557579,535106,702991,594811,74058,588630,25276,176694,764412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]