SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 987801 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 987801 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40680,411852,393774,662615,601070,635447,545661,649221,750788,131899,996749,260743,991461,609239,420858,720040,179243,80485,1046007,634453,1004671,1048896,716001,787859,859669,915440,674799,981094,341868,407417,603181,7016,511236,661861,913189,147030,700448,162124,244207,61356,785458,460951,313193,679944,1041542,76620,88617,755440,475870,69326,373413,541358,368582,691962,425866,483027,142180,705621,758960,129539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 987801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 987801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000370s ]