SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343260 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343260 [ RunTime:0.002649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149887,553506,431100,721334,357829,686486,426830,779469,907069,736104,94989,612720,641138,1015308,300956,415270,90703,539990,114668,472684,738159,601944,447778,621508,249233,772932,99703,452928,633997,500146,957500,876107,272384,658102,472814,203082,923166,521149,509140,208394,223643,655651,437712,872976,459987,523639,174879,585594,713909,672877,964336,614626,970938,72898,744564,150628,303748,587437,1010791,511722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]