SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468800 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468800 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408227,721095,643753,599105,984353,9945,654808,537536,627523,943454,204007,352260,916519,82725,526247,860281,821039,751866,784935,448098,895392,592499,35314,852503,864875,758549,131802,433143,255034,20631,933573,222051,365629,375558,219017,367198,388472,480411,441901,547887,162186,802580,956793,498563,83306,449733,940557,184345,215019,446457,558772,121504,875365,837809,71704,407519,620969,440395,528253,837223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]