SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174410 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174410 [ RunTime:0.003118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349569,589566,419170,971309,151457,918325,520122,447395,29753,891897,953566,975465,262608,563717,1020460,225404,208976,30417,655411,910577,553976,441993,552510,327043,127559,777504,673252,832952,764198,330003,330274,626232,180765,369843,23596,480806,255509,243942,710567,409101,514204,777075,188739,811037,761849,235282,611683,409672,596339,187663,514059,1029877,297638,984508,993180,291230,725169,443699,467069,339824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001087s ]