SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313435 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313435 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432517,733267,803459,992293,993003,236944,253438,969333,125563,625005,559658,826739,341947,433063,804583,680549,568496,692952,93287,553213,876881,590723,997287,87301,400944,77599,554464,829921,770420,864694,930327,189122,139506,534516,287710,488893,362090,869756,344925,241316,443652,295752,25612,785166,125418,304555,389197,807172,887050,437195,1034605,149237,315240,139420,380235,708006,1041530,16413,722228,471427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]