SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245417 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245417 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327178,1009149,820912,548766,55429,561557,443912,211957,404968,58686,133312,1017191,471196,851261,131641,429792,764540,807143,862675,1040266,341787,813045,33239,212226,215433,601461,741169,790170,938641,134146,345685,860109,143880,1009239,984598,858884,405035,627504,772389,190946,668253,26934,446840,946778,943196,958957,776319,833822,888096,551455,532020,325452,112369,852959,750350,951323,353980,1009163,37954,314358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]