SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001988s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015487 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015487 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477202,356525,361985,798152,765935,398128,98024,1023697,853270,199759,237871,649977,550585,769858,860299,570390,290789,417635,799971,8376,810421,1028244,486529,396606,536688,811394,963624,150068,1018296,889573,261732,180563,650579,550425,1010981,834129,988459,566585,47717,767983,560843,464069,335054,1006148,625025,81386,318422,273359,370798,822028,209713,78600,54319,382583,290428,41429,520306,328913,396587,841286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]