SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019788 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019788 [ RunTime:0.002251s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806674,405207,409881,616325,839357,909786,452071,776498,484424,301986,129216,401651,413121,270962,321775,368428,281931,948243,312694,821487,502650,610035,997102,282631,564111,242196,466288,269995,977917,378143,721911,718150,526911,849647,909082,282062,252233,816479,383054,341774,237691,306457,926308,185193,705593,623703,996114,953846,444555,812486,659261,782677,192025,714321,89610,132901,552554,961586,624389,848163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019788 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019788 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001418s ]