SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003596s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039217 LIMIT 1 [ RunTime:0.002683s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039217 [ RunTime:0.003415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403213,120753,204487,731368,32804,868003,341865,931845,672676,386365,284249,578341,520569,634791,14058,156555,67254,82670,416758,160278,635900,40108,66008,567350,541183,211445,590814,303658,367905,226803,958552,9862,891244,751872,711727,539845,942687,736613,828875,332655,118244,855117,177792,37933,765599,953264,667214,372300,676397,838101,297499,379599,940648,760555,67077,888134,728165,762410,87778,223890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]