SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201302 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201302 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32919,273362,298827,138451,284026,591170,872446,470377,273955,694494,984943,123076,276166,838884,256560,776358,292430,137849,379338,335496,656420,612309,520472,691555,136202,772511,677179,1032145,1016508,999879,627274,263266,488679,68547,98008,716938,693849,584334,437159,532344,821634,998289,878210,723662,467477,136149,884490,435567,148538,707844,584374,200888,721087,123322,679968,334932,920768,518996,613619,539954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]