SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49449 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49449 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111904,1113,564268,521900,169285,732509,143597,508434,101045,499620,522142,38370,271120,154486,121208,607435,867486,226341,504934,287326,931752,433017,1033042,512901,812447,794454,407097,1034041,259369,1029132,810753,386312,1040541,961105,929376,14049,449620,816028,156773,826793,162111,160984,617203,664418,841997,797771,899397,419071,185831,637210,325463,170951,493635,176495,675163,555970,1001947,468347,349340,745636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]