SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009014 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009014 [ RunTime:0.003175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37327,756263,573057,169584,1023176,468769,791379,1003691,497946,590297,926659,1043236,95858,407204,786954,703837,464873,199769,332927,896754,709806,466596,836525,1002268,65187,376681,886652,221822,143697,75980,271203,554066,690442,51478,250666,1010093,1034284,225369,504076,135426,655217,70530,398593,765328,1046706,36731,96006,494237,530028,618434,463081,823463,910643,487557,34673,475878,549358,1005122,559253,321599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]