SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602592 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602592 [ RunTime:0.003003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622592,719871,726317,522552,728009,786657,283708,464050,713546,145100,726840,409689,690433,903978,667710,353646,441539,594442,31507,1026879,674180,399128,501371,289075,415826,388276,247862,514156,50799,348319,585577,866194,481420,187614,919459,1036714,1018549,125612,67366,95973,475773,791374,358575,685081,302620,748916,732794,569489,239700,744999,101386,66397,1035113,769613,375007,766867,129715,325463,796834,631447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]