SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516059 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516059 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504039,413362,179559,615182,866458,814856,448712,892747,813571,632839,195310,257489,842160,89929,117443,965109,308991,904320,986259,451743,136939,253030,506283,72234,552213,1005598,655028,327903,257781,675639,743979,998972,233743,761363,163050,588955,249256,282279,401448,910847,370898,559569,344715,687463,952324,561248,761831,567799,201219,988873,252361,675957,21856,739855,171704,113691,203143,993761,222138,624765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]