SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287918 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287918 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401179,524454,579917,205507,697754,961429,452980,81471,325756,601408,1035575,183043,356734,523231,278226,1041599,637853,248445,105105,225969,300842,374262,514037,597205,937284,781820,150488,893124,873429,563418,382741,150782,972322,312600,506108,15429,371378,989274,405092,507729,658145,201641,87253,808412,167683,516642,267394,809016,527488,533997,772478,178689,391106,250191,177651,165943,691792,713927,28641,324080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]