SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010987 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010987 [ RunTime:0.002435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213054,468297,345950,250915,140125,813050,54842,616450,326409,703504,837676,287844,236285,702609,106716,863844,675066,44622,758569,333672,880754,441211,162332,314094,1014228,949753,149946,459670,802463,922727,616384,999618,103818,882850,33030,46654,195030,895451,337984,270238,959032,564787,720109,596206,790980,706645,140982,697011,61086,815791,268062,470828,870728,239453,699118,129605,985329,564650,251027,361819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]