SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 139198 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 139198 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452518,24619,1026849,478621,429455,1001899,187749,41686,71237,505214,1035838,841800,1014106,19228,983948,380469,834934,913179,12933,114096,430651,573902,767388,530040,663369,176156,960012,703031,209045,594629,654467,738700,98742,721536,471564,329618,517603,99026,277188,231610,176044,930447,691428,619045,629537,586190,153346,559365,434651,511752,215621,332722,827910,642509,18942,237504,674518,955239,285976,347319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 139198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 139198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]