SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338318 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338318 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979764,71349,754803,483136,157043,974186,671650,993513,932176,343126,583217,591443,756672,755689,465247,51094,327656,360858,830752,1014931,634426,941211,834261,182328,651830,97944,300681,918168,1036456,312709,702283,247237,566057,971884,12546,241579,512435,465252,21047,182196,943856,584262,25371,439470,1020037,752297,51445,65911,709072,460184,986784,515157,354756,601513,427629,303098,110018,1027920,260437,654612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]