SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38690 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38690 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634293,751133,896105,464582,918444,429535,1685,139614,295375,943574,513206,119664,382301,341209,831040,256522,993282,497254,373814,293814,149955,607572,605188,513849,46643,25904,229518,242236,1025208,737342,466742,262970,664541,597624,963141,74728,243711,350203,1042455,25439,1047958,494869,81309,889972,134804,46037,876439,118125,38146,284975,376026,626876,777660,368389,951133,330085,601126,764363,513662,365531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]