SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002869s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584190 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584190 [ RunTime:0.006460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74680,552272,652069,315429,281604,572181,245249,865577,998809,170623,596941,875131,554191,1015839,116628,556066,123984,53402,495629,961790,47003,156078,273027,278207,772142,754331,489916,1028929,138934,122541,988986,54378,1025890,185093,84809,438221,413643,89942,36982,290374,853538,247389,60856,777673,154456,174566,414641,128352,919450,645008,299499,1013790,717758,227310,1007152,966449,900523,37106,561185,783790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]