SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405808 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405808 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022059,329490,267331,358111,649197,288322,791655,447563,751991,763867,801168,816604,812904,286165,609572,125605,963224,726834,146406,544079,777435,483138,852346,255425,579563,300379,103042,448824,936317,817585,605286,429753,909221,1003999,561465,248761,943077,558306,712650,180915,978281,270964,939364,38694,948828,455761,459015,510591,653850,403167,837842,601527,1002842,1008511,245443,552689,497907,514958,1025859,320620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001913s ]