SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195928 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195928 [ RunTime:0.003635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964930,383881,157408,866693,465501,501660,547570,80663,768117,619408,519954,871682,613647,517234,225871,360715,656045,295368,532341,932924,244156,789143,111192,837228,836561,860245,346171,387172,1040732,744971,737920,108045,247679,567871,198180,734530,1032369,977825,844066,408255,152651,36279,66883,399146,340184,253294,628254,33166,127240,31912,22827,3867,979858,663010,472826,147509,242319,788458,298315,433208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]