SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103008 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103008 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994022,694506,1019400,120091,1038303,900245,847520,324463,148803,789147,78872,1029513,3870,276239,594153,231116,573774,855856,899436,290515,261933,412430,640970,347632,377988,588390,238162,524574,211456,642903,441465,1019035,792400,250966,999787,366258,314127,665895,395627,425345,929228,990718,77475,728260,663712,260843,322490,714468,384794,422868,986628,84118,168617,900894,121323,711263,1042008,674137,329236,556628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]