SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017716 LIMIT 1 [ RunTime:0.000914s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017716 [ RunTime:0.008024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384707,592104,540380,979762,431678,449826,62648,225255,897289,811200,469077,868232,248767,101981,651764,780845,986906,1045130,224243,1004137,671754,957396,166801,277424,589251,116781,664893,267168,667088,550957,999763,135611,295534,458473,698261,235188,764888,249428,123623,769796,643953,978812,797371,375695,928266,1018441,292302,258657,394590,897765,763741,702999,268794,228162,795766,839011,486802,472096,517006,815973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002940s ]