SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804163 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804163 [ RunTime:0.002632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033270,517211,156781,42070,344231,766713,932965,53798,789812,19161,823429,1010116,111647,964560,645566,397821,166257,259687,147368,37206,945219,658244,576586,793855,305981,736078,785709,860657,245500,820151,577945,365280,405575,116185,777708,510027,527363,586253,832356,185734,47322,681014,904820,849471,38462,323245,411126,256057,501600,91112,386769,1034467,410898,389402,34083,695716,1046190,1031550,688949,452221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]