SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51636 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51636 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612730,408565,171460,593851,168832,381102,726970,868424,420637,206548,634369,199243,643573,58829,31929,292818,370136,201722,505531,229331,866077,834764,778058,957181,548657,131402,649960,711190,145140,856071,639961,127121,889594,992950,176280,366225,86465,259888,629572,412094,969428,782692,977546,444482,106099,27162,151866,943072,972110,921336,224383,705637,198375,281868,878974,598561,711994,408457,387529,504104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]