SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415763 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415763 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687511,981578,41399,200315,1014643,344887,277384,805046,937575,780938,1040706,495920,562799,902999,1042208,166093,355975,489087,386979,168400,224834,1003885,1001195,585742,732009,126666,891484,650167,300427,652579,736965,348251,665717,125405,348281,358011,839773,895177,75604,88501,472821,921574,440048,116248,146921,545833,613247,803697,179740,119571,820502,380557,505808,1156,897735,215030,826596,153433,204895,187527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]