SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502090 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502090 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813672,683508,120918,467193,62019,1031010,330201,404737,172557,253559,167369,705699,531246,61,487214,617818,368571,525202,747528,145153,845178,731489,453716,2450,822290,590234,765686,277855,108320,814517,719892,891374,854272,761032,335429,477587,616207,434420,516158,13070,989607,182164,947351,975396,521091,843259,844938,423780,673330,430683,474666,140077,609627,578099,821521,465604,773226,418314,617250,768708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]