SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354098 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354098 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562820,4026,430607,975368,317417,681941,777291,291125,151516,663070,829074,668306,41282,897335,480571,673852,747537,270145,141055,69639,215176,655893,540612,916153,239757,423243,903813,517753,84157,52021,980129,814573,967457,905261,141580,939300,677215,851498,19740,331104,612991,991147,2424,587996,756775,222823,42037,775163,539616,163649,767061,98838,933414,151472,516420,950429,249606,777350,794704,733700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]