SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53928 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53928 [ RunTime:0.002989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311505,7990,149082,860310,251489,548683,110334,884754,407672,984480,295953,669931,226514,388809,620858,136767,624929,575579,865405,578587,704595,987622,781000,373373,735726,265999,359652,695819,213672,13994,718695,388723,861913,129396,106589,877343,2885,315904,28095,685066,796544,566887,280350,1010925,824636,251414,68142,508608,164541,712259,115316,525776,117356,623397,466608,101532,789074,90592,871790,182997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001805s ]