SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107724 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107724 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569502,374686,227190,440504,123227,707326,21657,134562,54394,408550,437555,376611,924845,592535,79896,287882,79038,346178,803545,989024,150163,646947,358192,917363,372463,668453,200609,422546,101163,56338,550064,715186,925555,384384,104417,851507,569278,422018,224166,432930,356341,655820,1046503,25161,772687,14085,1047365,600967,455397,861472,315346,425518,659152,180149,1023678,141040,272566,332236,949790,935485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107724 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107724 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]