SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002776s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685376 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685376 [ RunTime:0.004685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538197,257812,303737,549907,883429,501153,133022,340466,894715,644732,510697,253719,849165,1033590,778088,122431,481556,262629,749062,888505,160270,619838,351067,325854,999291,665405,1037306,985411,855898,808417,464713,628446,363775,762877,186696,710820,36114,875586,621001,51387,989413,777842,86229,609058,998983,528069,304490,573831,359809,1040564,1037625,620882,698859,69589,381735,208805,49989,1002916,231796,481932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]