SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51346 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51346 [ RunTime:0.002635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602766,123714,207952,426782,133529,282602,274312,975584,404564,812309,904221,363391,319208,119019,459723,251254,668842,313137,132889,343588,288792,713873,253164,163580,434021,949929,511756,44898,944152,581478,214504,209281,495767,98126,1029349,91537,542191,179251,701526,278095,381507,583674,762136,115582,373992,662001,690677,394223,978995,934120,166753,935009,268461,564136,744716,619965,938381,870948,390678,400742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]