SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 363418 LIMIT 1 [ RunTime:0.000679s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 363418 [ RunTime:0.002574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450870,320833,47897,518630,480508,636254,704262,590312,18967,228354,439313,206989,463775,236668,354468,451658,1014501,809069,416666,549163,104901,1007320,71910,107601,1048449,201659,396439,1043655,238390,788700,765464,154248,1013774,64337,257821,1037965,378086,269735,3616,804378,248059,769189,502176,254547,202288,1029878,953838,447922,584142,991210,147774,397266,213933,989059,545113,892256,951617,431595,979197,562246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 363418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 363418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001670s ]