SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 881404 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 881404 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577490,1034802,552308,1048820,420805,528512,905612,664650,988307,102345,1018753,505352,305119,176785,653093,136931,887520,677581,868103,805374,724289,879838,227647,584468,725006,108937,752457,982164,830480,295370,1036609,445044,673759,397753,675132,1038006,69777,590927,13096,535407,260230,714259,930458,29457,392413,123388,988276,221941,521446,166780,474275,833767,894405,370450,9717,263111,995297,1019934,624373,884680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 881404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 881404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]