SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201193 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201193 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174959,141492,744398,671978,420901,306187,369153,520396,337329,166960,179985,456914,397744,256289,909116,758453,1047817,208877,722345,459814,374212,941291,769177,98581,486627,198937,134654,531287,1046902,518600,866165,488203,838574,457852,408689,320503,804386,663583,622466,450990,203438,299261,611218,237519,731377,897059,831883,473637,37793,888685,347320,59127,483194,193087,572864,154452,1030900,5292,404701,434122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]