SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341207 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341207 [ RunTime:0.002057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323937,477509,667203,544459,119595,754408,955308,79007,577710,404187,304866,236917,356920,216773,705086,846210,546591,140173,250158,614619,494901,512189,819208,492618,856017,1031473,687966,811809,764266,564112,90208,836735,391568,572226,76865,958327,945643,980520,63594,403446,320474,878324,595668,1026430,446870,566765,1026565,791555,191050,735361,319204,977041,743511,637536,369734,430608,460819,394256,175938,934408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]