SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526163 LIMIT 1 [ RunTime:0.000808s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526163 [ RunTime:0.003082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960284,555497,163157,910050,17502,350284,709324,841190,791759,347151,526076,669639,140497,425032,252575,1041304,265670,299125,222917,227446,231201,724040,489189,158196,31866,736195,365888,395220,917858,721753,66526,343815,831196,260609,933101,1020119,855207,740406,390489,431437,225776,500074,771804,954491,422787,678797,704757,149716,173634,180843,37389,476597,392224,841043,755527,304816,574109,863713,917843,418262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]