SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001926s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292291 LIMIT 1 [ RunTime:0.003376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292291 [ RunTime:0.002970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425557,1043541,845588,815156,1021167,781570,525390,197614,768356,741762,736228,496221,407893,591458,872619,695814,398316,527752,55541,593658,564536,244637,890701,617997,1023757,977743,297724,803282,557494,72389,925542,716544,704302,364321,1033970,997330,1024103,827176,851908,1003043,785131,966542,1014012,450257,908733,1046034,36718,269884,939946,742414,495105,1010567,1030640,691233,418418,753619,284879,749881,422453,539960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]