SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101908 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101908 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416110,331774,512710,412956,829884,109363,182231,537974,654267,564732,661013,78266,272681,981969,562596,158771,221850,748094,923209,76685,397553,185015,725027,803445,940653,662349,794296,397655,61699,723209,888452,594628,315936,132557,978360,570879,679996,392161,20964,359368,160171,663609,360616,631752,195284,202163,411214,886289,554726,511347,338998,455650,380772,446478,805236,981664,300842,708666,967129,1010117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]